package com.yxinsur.imc.business.excel;

import com.yxinsur.imc.common.annotation.Excel;
import lombok.Data;

import java.math.BigDecimal;
import java.util.Date;

@Data
public class ContractExpenseRateTemplate {
    private static final long serialVersionUID = 1L;

    /**
     * 序号
     */
    @Excel(name = "序号*", cellType = Excel.ColumnType.NUMERIC, prompt = "数据行请保证序号不为空")
    private String index;

    //险种内部代码
    @Excel(name = "险种内部代码", prompt = "注意：应为产品配置的险种内部代码而非保险公司险种代码", type = Excel.Type.IMPORT)
    private String riskCode;
    // 缴费期间起
    @Excel(name = "缴费期间[起]*", cellType = Excel.ColumnType.NUMERIC, prompt = "缴费期间应为正整数(年)", type = Excel.Type.IMPORT)
    private Integer chargePeriodLowerValue;
    // 缴费期间止
    @Excel(name = "缴费期间[止]*", cellType = Excel.ColumnType.NUMERIC, prompt = "缴费期间应为正整数(年)", type = Excel.Type.IMPORT)
    private Integer chargePeriodUpperValue;
    // 保障期限起
    @Excel(name = "保障期限[起]*", cellType = Excel.ColumnType.NUMERIC, prompt = "保障期限应为正整数(年)", type = Excel.Type.IMPORT)
    private Integer coveragePeriodLowerValue;
    // 保障期限止
    @Excel(name = "保障期限[止]*", cellType = Excel.ColumnType.NUMERIC, prompt = "保障期限应为正整数(年)", type = Excel.Type.IMPORT)
    private Integer coveragePeriodUpperValue;
    // 保单年度起
    @Excel(name = "保单年度[起]*", cellType = Excel.ColumnType.NUMERIC, prompt = "保单年度应为正整数", type = Excel.Type.IMPORT)
    private Integer payYearLower;
    // 保单年度止
    @Excel(name = "保单年度[止]*", cellType = Excel.ColumnType.NUMERIC, prompt = "保单年度应为正整数", type = Excel.Type.IMPORT)
    private Integer payYearUpper;
    // 领取年龄起
    @Excel(name = "领取年龄[起]", cellType = Excel.ColumnType.NUMERIC, prompt = "年龄应为正整数", type = Excel.Type.IMPORT)
    private Integer pensionAgeLower;
    // 领取年龄止
    @Excel(name = "领取年龄[止]", cellType = Excel.ColumnType.NUMERIC, prompt = "年龄应为正整数", type = Excel.Type.IMPORT)
    private Integer pensionAgeUpper;
    // 方案名称
    @Excel(name = "方案名称", type = Excel.Type.IMPORT)
    private String insSchemeValue;
    // 扩展1
    @Excel(name = "扩展1", type = Excel.Type.IMPORT)
    private String factor1Value;
    // 扩展2
    @Excel(name = "扩展2", type = Excel.Type.IMPORT)
    private String factor2Value;
    // 扩展3
    @Excel(name = "扩展3", type = Excel.Type.IMPORT)
    private String factor3Value;
    @Excel(name = "费率生效时间[起]*",dateFormat = "yyyy-MM-dd")
    private Date startDate;
    @Excel(name = "费率生效时间[止]",dateFormat = "yyyy-MM-dd")
    private Date endDate;
    // 费率
    @Excel(name = "费率*", prompt = "[基础手续费率]应为小数类型，应输入0.9不必输入90%")
    private BigDecimal rate;
}
